Setting Advanced View Properties

The Advanced tab allows you to restrict the defining query of the view.

Restrict query

Read only
Indicate that the table or view cannot be updated.

Check option
Indicate that Oracle Database prohibits any changes to the table or view that would produce rows that are not included in the subquery.

Constraint Name
Specify the name for the restrict query. If you omit this identifier, then Oracle automatically assigns a Constraint Name of the form SYS_Cn, where n is an integer that makes the constraint name unique within the database.

Force on create
Check this option if you want to create the view regardless of whether the base tables of the view or the referenced object types exist or the owner of the schema containing the view has privileges on them.